select
	r.id,
	r.realName,
	r.sort,
	IFNULL(s.jyAmountTotal, 0) jyAmountTotal
from
    t_pay_account r
left join (
    select alipayMobile, sum(jyAmount) jyAmountTotal
    from t_stl_sell where status = 'Success' and insertTime >= date(now())
    group by alipayMobile
) s on r.mobile = s.alipayMobile
where
    r.worked = 1
and r.alipayFilename is not null